|
|
The attributes of a Trading Partner, i.e. the values from the General tab and Contact Details tab, can be used in Flow in several ways:
The references to attributes as Tags, Properties, and columns are listed in the table below.
|
Trading Partner Attribute |
Trading Partner Tag |
Partner Object Property |
Database Column |
|---|---|---|---|
| (Flow ID) | <TPId> | Partner.Id |
[FID] [uniqueidentifier] |
| Partner Name | <TPName> | Partner.CompanyName | [MODULENAME] [varchar](255) |
| Partner Type | - | Partner.PartnerType | [PARTNERTYPE] [int] |
| Your ID for them as customer | <TPCustomerId> | Partner.CustomerId | [CUSTOMERID] [varchar](100) |
| Their ID for you as supplier | <TPTheirSupplierId> | Partner.TPSupplierId | [TPSUPPLIERID] [varchar](100) |
| Your ID for them as supplier | <TPSupplierId> | Partner.SupplierId | [SUPPLIERID] [varchar](100) |
| Their ID for you as customer | <TPTheirCustomerId> | Partner.TPCustomerId | [TPCUSTOMERID] [varchar](100) |
| Custom Id | <TPFlowNetId> <TPMemberID> |
Partner.FlowNetId | [MEMBERID] [varchar](50) |
| User Name | <TPUsername> | Partner.Username | [USERNAME] [varchar](35) |
| User Password | <TPPassword> | Partner.Userpass | [USERPASS] [varchar](255) |
| First Name | <TPFirstName> | Partner.FirstName | - |
| Last Name | <TPLastName> | Partner.LastName | - |
| Address (field 1) | <TPAddress1> | Partner.Address1 | - |
| (Address field 2) | <TPAddress2> | Partner.Address2 | - |
| Suburb | <TPAddress3> | Partner.Address3 | - |
| City | <TPCity> | Partner.City | - |
| State | - | Partner.AddrState | - |
| Country | <TPCountry> | Partner.Country | - |
| Phone | <TPPhone> | Partner.Phone | - |
| Fax | <TPFax> | Partner.Fax | - |
| <TPEmail> | Partner.Email | - |